Manchester City are out of the Champions League after Monaco struck late to seal a thrilling away-goals victory, which ended 6-6 on aggregate.